﻿CREATE TABLE [dbo].[CallCenter] (
    [Id]           INT              IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [GId]          UNIQUEIDENTIFIER CONSTRAINT [DF_CallCenter_GId] DEFAULT (newid()) ROWGUIDCOL NULL,
    [CompanyId]    INT              NULL,
    [DepartmentId] INT              NULL,
    [UserName]     NVARCHAR (50)    NULL,
    [EName]        NVARCHAR (50)    NULL,
    [ZXNum]        INT              NULL,
    [FJNum]        INT              NULL,
    CONSTRAINT [PK_CallCenter] PRIMARY KEY CLUSTERED ([Id] ASC)
);


GO
CREATE NONCLUSTERED INDEX [IX_CallCenter_CompanyId]
    ON [dbo].[CallCenter]([CompanyId] ASC);


GO
CREATE NONCLUSTERED INDEX [IX_CallCenter_DepartmentId]
    ON [dbo].[CallCenter]([DepartmentId] ASC);


GO
CREATE NONCLUSTERED INDEX [IX_CallCenter_ZXNum]
    ON [dbo].[CallCenter]([ZXNum] ASC);


GO
CREATE NONCLUSTERED INDEX [IX_CallCenter_UserName]
    ON [dbo].[CallCenter]([UserName] ASC);

